from x01_stock.xx_util.DBUtil import SqlHelper

val = ['区间涨跌幅:前复权(近5日)[20240729-20240802]:18.21', '区间涨跌幅:前复权(年初至今)[20240102-20240802]:-43.79', '区间涨跌幅:前复权(近3日)[20240731-20240802]:14.67', '区间涨跌幅:前复权(近20日)[20240708-20240802]:9.9', '区间涨跌幅:前复权(近三个月)[20240506-20240802]:-25.05', '区间涨跌幅:前复权(近一年)[20230802-20240802]:-39.22', '区间涨跌幅:前复权(近一个月)[20240702-20240802]:7.5', '区间涨跌幅:前复权(近10日)[20240722-20240802]:22.86']
sql = ('update stock_first_zhangting_wencai set '
       'jin5rizhangfu = %s , '
       'nianchuzhijinzhangfu =  %s ,'
       'jin3rizhangfu =  %s ,'
       'jin20rizhangfu =  %s ,'
       'jin3yuezhangfu =  %s ,'
       'jin1nianzhangfu =  %s ,'
       'jin1yuerizhangfu =  %s,'
       'jin10rizhangfu =  %s where stock_code = "600107.SH" and trade_date = "2024-08-03"');
SqlHelper.get_instance().execute_curd(sql, val)
